﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create TEST DATA ****/
PRINT 'INSERTING TEST DATA FOR LOGIN PROCESS.... [Ivy_Sys_OrganizationMaster]'
GO
SET IDENTITY_INSERT [Sys_OrganizationMaster] ON
INSERT [Sys_OrganizationMaster] ([OrganizationID], [OrganizationCode], [OrganizationName], [OrganizationDescription], [OrganizationDomainURL], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'SCTY_OGJEAFMEIU', N'Gokulm', NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Sys_OrganizationMaster] ([OrganizationID], [OrganizationCode], [OrganizationName], [OrganizationDescription], [OrganizationDomainURL], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SCTY_ELPWEIAXOE', N'New society', NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
SET IDENTITY_INSERT [Sys_OrganizationMaster] OFF

PRINT 'INSERTING TEST DATA FOR LOGIN PROCESS.... [Society]'
GO
INSERT [Society] ([SocietyKey], [SocietyCode], [SocietyName], [SocietyAddressLine1], [SocietyAddressLine2], [SocietyAddressCityName], [SocietyAddressStateName], [SocietyAddressCountryName], [SocietyAddressPinZipCode], [SocietyLocationLongitudeLatitude], [SocietyDefaulPhone], [SocietyLegalRegistrationCode], [SocietyAboutUsRemarks], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'SCTY_OGJEAFMEIU', N'Gokulm', N'K.s layout', NULL, N'Bangalore', N'Karnataka', N'India', NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [Society] ([SocietyKey], [SocietyCode], [SocietyName], [SocietyAddressLine1], [SocietyAddressLine2], [SocietyAddressCityName], [SocietyAddressStateName], [SocietyAddressCountryName], [SocietyAddressPinZipCode], [SocietyLocationLongitudeLatitude], [SocietyDefaulPhone], [SocietyLegalRegistrationCode], [SocietyAboutUsRemarks], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SCTY_ELPWEIAXOE', N'New society', N'Banshankari', NULL, N'Bangalore', N'Karnataka', N'India', NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 3, NULL, (SELECT @@SERVERNAME))

PRINT 'INSERTING TEST DATA FOR LOGIN PROCESS.... [Person]'
GO
SET IDENTITY_INSERT [Person] ON
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'kiran', N'k', NULL, CAST(0x0000A52500164B8F AS DateTime), N'k@gmail.com', NULL, 0, NULL, N'876511', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'mahesh', N'k', NULL, CAST(0x0000A5250017910A AS DateTime), N'k@gmai.com', NULL, 0, NULL, N'41213213', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'Abhi', N'k', NULL, CAST(0x0000A5250018F5C0 AS DateTime), N'y@gmail.com', NULL, 0, NULL, N'54651321', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'kailash', N'm', NULL, CAST(0x0000A52500192398 AS DateTime), N'm@gmail.com', NULL, 0, NULL, N'646132', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'Prathvi', N'g', NULL, CAST(0x0000A52500198D45 AS DateTime), N'g@gmail.com', NULL, 0, NULL, N'465461', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'veer', N'm', NULL, CAST(0x0000A525001A3B39 AS DateTime), N'v@gmail.com', NULL, 0, NULL, N'2211', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [Person] ([PersonKey], [PersonFirstName], [PersonLastName], [PersonSex], [PersonDateOfBirth], [PersonPrimaryEmailID], [PersonPrimaryEmailVerificationCode], [PersonPrimaryEmailIsVerified], [PersonAlternateEmailID], [PersonPrimaryMobileNumber], [PersonPrimaryMobileVerificationCode], [PersonPrimaryMobileIsVerified], [PersonAlternatePhoneNumber], [PersonAddressLine1], [PersonAddressLine2], [PersonAddressCityName], [PersonAddressStateName], [PersonAddressCountryName], [PersonAddressPinZipCode], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'jairus', N'noel', NULL, CAST(0x0000A525001B95DD AS DateTime), N'noel@gmail.com', NULL, 0, NULL, N'646132132', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, GETDATE(), GETDATE(), N'1', N'1', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
SET IDENTITY_INSERT [Person] OFF

PRINT 'INSERTING TEST DATA FOR LOGIN PROCESS.... [User]'
GO
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'kiran', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'2', N'2', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'mahesh', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'3', N'3', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'abhi', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'4', N'4', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'kailash', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'5', N'5', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'Prathvi', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'6', N'6', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'v@gmail.com', N'Db63vGIBJ5Wg7GOg+18wjQ==', 2, NULL, NULL, GETDATE(), GETDATE(), N'7', N'7', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [User] ([UserPersonKey], [UserLoginId], [UserPassword], [UserLoginIdType], [UserForgotPasswordQuestion], [UserForgotPasswordAnswer], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'jairus', N'Db63vGIBJ5Wg7GOg+18wjQ==', 1, NULL, NULL, GETDATE(), GETDATE(), N'8', N'8', 1, 0, 2, NULL, (SELECT @@SERVERNAME))

PRINT 'INSERTING TEST DATA FOR LOGIN PROCESS.... [UserOrganizationRole]'
GO
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, -1, 4, N'kiran', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'2', N'2', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, 3, 9, N'kiran', N'SCTY_ELPWEIAXOE', N'New society', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'2', N'2', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, -1, 12, N'kiran', N'SYSTEM', N'Not Member of any Society', N'LOCVENDOR', N'Vendor', GETDATE(), GETDATE(), N'2', N'2', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, -1, 4, N'mahesh', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'3', N'3', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 2, 6, N'mahesh', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTADMIN', N'Society Portal Admin', GETDATE(), GETDATE(), N'3', N'3', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 2, 9, N'mahesh', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'3', N'3', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, 2, 10, N'mahesh', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTFLTRES', N'Society Resident', GETDATE(), GETDATE(), N'3', N'3', 1, 0, 2, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, -1, 4, N'abhi', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'4', N'4', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, -1, 12, N'abhi', N'SYSTEM', N'Not Member of any Society', N'LOCVENDOR', N'Vendor', GETDATE(), GETDATE(), N'4', N'4', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, -1, 4, N'kailash', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'5', N'5', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, 2, 10, N'kailash', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTFLTRES', N'Society Resident', GETDATE(), GETDATE(), N'5', N'5', 1, 0, 2, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, -1, 4, N'Prathvi', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'6', N'6', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, 3, 9, N'Prathvi', N'SCTY_ELPWEIAXOE', N'New society', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'6', N'6', 1, 0, 3, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, -1, 4, N'v@gmail.com', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'7', N'7', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 2, 9, N'v@gmail.com', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'7', N'7', 1, 0, 3, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, 3, 10, N'v@gmail.com', N'SCTY_ELPWEIAXOE', N'New society', N'SCTFLTRES', N'Society Resident', GETDATE(), GETDATE(), N'7', N'7', 1, 0, 3, NULL, (SELECT @@SERVERNAME))

INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, -1, 4, N'jairus', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'8', N'8', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 2, 9, N'jairus', N'SCTY_OGJEAFMEIU', N'Gokulm', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'8', N'8', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, 3, 9, N'jairus', N'SCTY_ELPWEIAXOE', N'New society', N'SCTFLTOWN', N'Society Flat Owner', GETDATE(), GETDATE(), N'8', N'8', 1, 0, 2, NULL, (SELECT @@SERVERNAME))
